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
|