Search : in
By :

Creating IF formula that colors a cell

Last answer on Nov 19, 2009 9:38:42 am GMT Helene, on Oct 19, 2009 12:44:31 pm BST 
 Report this message to moderators

Hello,
I have a question re. an IF formula. I am creating a table, where I want Excel to color a cell in red, if no value has been entered. Colleagues tell me that I have to use a macro, but I am not sure how to. Any ideas?
Thanks in advance,
Helene

Configuration: Windows XP Internet Explorer 8.0
Excel 2003

Best answers for « Creating IF formula that colors a cell » in :
[Excel]changing cell formula to text Show[Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Excel – Formula for cell calculation ShowExcel – Formula for cell calculation Issue Solution Note Issue Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3) What is the proper formula to get the calculation to utilize J3 if...
The YUV (YCrCb) format ShowThe YUV standard The YUV standard (also called CCIR 601), known before as YCrCb (Y Cr Cb), is a colour representation model dedicated to analogue video. It is based on a video transmission mode with separate components using three different cables...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Ask your question Reply

1

Excelguru, on Oct 19, 2009 3:06:33 pm BST

Hello
Just conditional format the cell
you have to use a formula CELLADDRESS="" where you have to change CELLADDRESS with the cell address of first cell of such cells
A wise man once said, 'I complained that I had no shoes until I met a man who had no feet.'
I am interested in financial Modelling and custom excel development with excel macros.

   
Reply to Excelguru

2

 kong, on Nov 19, 2009 9:38:42 am GMT
   
Reply to kong
Ask your question Reply
They need your help