Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro for Conditionally Formatting Comments
Is there a way to write a macro to conditionally format a cell with text?
For the cell in question, I have written an IF statement that will enter a 1 when something is incorrect. I've written that formula to be =IF(A2<B2,1,""). For cells with a 1 in it, I've used conditional format to highlight it red. I also want to figure out a way for that cell to say "Check Times." How do I do that? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditionally formatting currency | Excel Worksheet Functions | |||
Conditionally Formatting | Excel Worksheet Functions | |||
Conditionally formatting rows | Excel Worksheet Functions | |||
Conditionally formatting other cells? | Excel Worksheet Functions | |||
Insert comments conditionally - ajit | Excel Discussion (Misc queries) |