• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

Change Cell Contents to a Colour

Hi there,

I have a number of user security spreadsheets to consolidate and rather than have an "X" to indicate access, I'd like to change the cell to GREEN. If no access and cell is blank then RED,

Can you provide any suggestions on how to do this?

Thanks in advance,
CS
0
rporter45
Asked:
rporter45
  • 2
2 Solutions
 
NBVCCommented:
So if the cell itself is blank, you want it to turn Red... and if it has something in it, then turn it Green?  Or is it another cell that is changing colour?

If it is the cell itself, then select the range, invoke conditional formatting \ New Rule. then choose Format Only Cells that Contain, then choose, Cell Value >> Is Equal To >> and enter =""  ... then format as RED

add a New rule and repeat with Cell Value>> Is Not Equal To >> =""  for Green
0
 
LCCSAMCommented:
The above solution would be the method of choice. I've included screenshots from excel 2013 for clarification.Select Conditional formatting from the Home tabEnter the rule as =""     then choose "Format" to alter the colorsCreate the rule for any particular cell entry. As far as I know there is no limit to the number of rules!
0
 
rporter45Author Commented:
Please accept my apologies! I completely forgot about this - I will be working on this today and will follow up -

Thank you very much,
CS
0
 
rporter45Author Commented:
Works perfectly - I found the screen shots to very helpful and easy to use,

Thank you both!
CS
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now