Hello,
I am trying to format a whole table.
I have a column titled status with either 0 and than green, ! and then yellow or X and the red.
Now I want the Conditonal Formating not only applied to just the Singel column but the whole line, depending on the Statuscolumn.
Status A B C If here is 0 then this should be GREEN If here is ! then this sould be YELLOW If here is X Then this should be RED
Just use the 'Use a formula to determine which cells to format' option
Specify the CF in the status column, e.g. =$A2=0 and apply this to the whole of the table. I'm assuming your table is actually columns A:D and that status is in column A
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Assuming the status column is column 1 and your data starts in column 1, row 2, select cells A2 down to the end of your data/table. Select Conditional Formatting, choose use formula and type in the box:for the first condition and format as Green. Repeat for the other conditions withFormula:
Please Login or Register to view this content.andFormula:Please Login or Register to view this content.Formula:Please Login or Register to view this content.
Depending on your regional settings, you may have to replace the comma (,) with a semi-colon (
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks I got it
What if you're trying to cross from another sheet/tab ? How would that formula work then?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks