Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight cells based on conditions
I need to highlight cell B if it is greater than cell C of the same row,
providing that cell C is NOT blank. All cells formated as date. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight cells based on conditions
I had this type of question answered on 4/28/09 in the Excel Function
questions. Title is "Change Colr on rows, after and IF Funtion is answered" You would use the Conditional Formatting on the cell. "Vic" wrote: I need to highlight cell B if it is greater than cell C of the same row, providing that cell C is NOT blank. All cells formated as date. Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight cells based on conditions
Format Conditional Formatting... FormulaIs
=AND(C1<"",B1C1) and pick a nice background color -- Gary''s Student - gsnu200850 "Vic" wrote: I need to highlight cell B if it is greater than cell C of the same row, providing that cell C is NOT blank. All cells formated as date. Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight cells based on conditions
On Apr 30, 11:27*am, Vic wrote:
I need to highlight cell B if it is greater than cell C of the same row, providing that cell C is NOT blank. All cells formated as date. Thank you. You can use conditional formatting for this. Select Column B - Go to Format - Conditional formatting - Cell is - Greater than - ... I think you can proceed from here. Just change the format to highlight B. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight duplicate cells based on a selected cell | Excel Discussion (Misc queries) | |||
How to sum cells based on conditions | Excel Worksheet Functions | |||
Highlight duplicate cells based on a selected cell | Excel Discussion (Misc queries) | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
Macro to highlight cells based on content | Excel Worksheet Functions |