Hey Guys,
Wondering if you can help...
I have a spreadsheet to look at computer equipment at work. (see attached - this is a small part of the sheet).
I want to add a rule so that if i add Printer in column E it blacks out column F and G (as they are not needed)
How would i do this?
Thanks
Select F5
Conditional Formatting
New Rule
Use a formula to determine...
=($E5="Printer")
Format as black
Use Format painter (paintbrush icon) to copy to other cells
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi, use = $e5="Printer" as the formula in CF. See attached.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thanks guy, you both helped me out!
You're welcome .... and thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks