How do you do....it? Thread, Conditional formatting help needed in Technical; ...
3rd June 2008, 01:12 PM #1
Conditional formatting help needed
Iíve been trying to use conditional formatting on an Excel spreadsheet and I need help!
The spreadsheet has 5 columns. Surname, Forename, Reg, DOB, Permission and I want to highlight the rows depending on the value in the permission cell. So if the permission cell = YES I want the whole row to be highlighted green and if the permission cell is NO I want the whole row to be highlighted red. Using conditional formatting I can get the permission cells to change colour but not the whole rows.
3rd June 2008, 01:29 PM #2
Rather than basing your conditions on a cell value, you have to base the condition on a formula instead.
Have used this many a time before and its straightforward enough, instructions for you here
Thanks to AngryITGuy from:
3rd June 2008, 01:30 PM #3
I've done this as a demo spreadsheet for you to try: download it here.
3rd June 2008, 02:58 PM #4
Thanks, that was spot on.
Originally Posted by sdc
By laserblazer in forum Web Development
Last Post: 29th October 2007, 10:34 AM
By randle in forum Windows
Last Post: 25th October 2007, 02:20 PM
Last Post: 4th June 2007, 10:10 PM
By ITWombat in forum Comments and Suggestions
Last Post: 16th October 2006, 09:34 AM
By chrbb in forum Windows
Last Post: 21st February 2006, 12:36 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)