Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating
My data looks like this:
A B C D 0.00% 0.00% 100.00% 0.00% 5.92% 7.06% 13.98% 32.51% 4.05% 11.19% 17.65% 54.46% Is there a way to entire row if any value in the row is greater than 50% and/or Bold the Font of ColB if the cell value is less than 2%. So in data above, rows 1 and 3 would be highlighted and B1 would be Bold Font. Thank you in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating
Because once it satisfies one condition it doesn't test later ones, you may
need to do it in stages. For the whole range, set Formula is: =MAX($A1:$D1)50% to highlight the rows. Then for column B change it to 3 conditions: First condition: Formula is: =AND(MAX($A1:$D1)50%,B1<2%) to highlight and bold Second condition: Cell value is: less than: =2% to bold Third condition: as for whole range above. -- David Biddulph "carl" wrote in message ... My data looks like this: A B C D 0.00% 0.00% 100.00% 0.00% 5.92% 7.06% 13.98% 32.51% 4.05% 11.19% 17.65% 54.46% Is there a way to entire row if any value in the row is greater than 50% and/or Bold the Font of ColB if the cell value is less than 2%. So in data above, rows 1 and 3 would be highlighted and B1 would be Bold Font. Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating | Excel Worksheet Functions | |||
conditional formating | New Users to Excel | |||
Conditional Formating IS: Help With ANY VALUE | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) |