Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hey everyone!!
My question is: I am using Conditional Format to change the color of a cell when two other cell are different. For example : I type in under condition 1 "formula is" =if(a1a2,"true") and under format change the cell red. When I do this nothing happens but if I type this in a if statement then it works but I don't have the option to color the cell. My question is how do I do a if statement or what is wrong with my above statement in conditional format. Also can you do multi statement in one format. Thanks Mark Melancon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Format (not color format) | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |