Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlight a column
Thanks for your reply.
The row willl change as more employees are added and deleted. Do you know how to sum a column that is dynamic? Thanks, Misty Pranav Vaidya wrote: Select the entire column I assume your total is on row 14. You can change it as per actual total line. Go to Conditional formatting and select 'formula is' type in this formula '=IF($B$14200,TRUE,FALSE)' select the color to hightlight. This will highlight the entire column, when value in B14 is more than 200. Please adjust this formula as per your worksheet. HTH, Hi Everyone. Please help me. I am trying to figure out how to write a conditional [quoted text clipped - 14 lines] Thanks, Misty -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200709/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I cannot highlight a whole row or column | Excel Worksheet Functions | |||
highlight column A if column A does not equal to B | New Users to Excel | |||
How do I highlight a column depending on other column value? | Excel Worksheet Functions | |||
how to set highlight for row/column header | Excel Discussion (Misc queries) | |||
How to highlight active row and column? | Excel Programming |