View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Fill color with if function

Hi,

Use conditional formatting.
Select A1 then
Format|Conditional Formatting
Formula is
Enter the formula =A24
Pick you colour
OK

Mike

"maz" wrote:

Hi.
I want to fill a cell with some color based on the value in other cell.
if a24 then a1 is blue.
Can anyone help me?
thanks