I want a row of cells to be the same color as a certain cell. How do I get this to happen automatically? I have a attach a file that shows what I have so far.
Cell colors.jpg
I want a row of cells to be the same color as a certain cell. How do I get this to happen automatically? I have a attach a file that shows what I have so far.
Cell colors.jpg
Please upload a excel file that tells a lot more than a pict.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Shift Calendar 2017.xlsx
Here ya go. Thank you.
=$H3="C/B"
Use this formula in CF
what is CF? Won't that mess up my formula I already have in the cells for the dates?
CF is conditional format.
Wonderful. Thank you so much. Don't go anywhere, I may have another problem.
on that same spread sheet on the first tab, I need to make each date reflect the same color as the next tab. is that done with conditional formatting too? Which CF do I choose?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks