Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting?
Excel2003 ... To turn pattern of every other row ... I am using conditional
format formula ... =mod(row(),2)=1 to change Font RED for any Cell Value ending in "P/T" ... I am using conditional format formula ... Right(Cell,3)="P/T". Above said ... I would like to write conditional format formula that will do both at the same time ... Alternate Cell Pattern for every other row & Font Pattern RED for any Cell Value ending in "P/T". Thanks ... Kha |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |