yiixa
New member
- Joined
- Dec 8, 2013
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Hi everybody,
Is there a way to change color of letters (font) in a cell if it equals the value of another cell WITHOUT changing the background color?
My table has alternate rows of slightly different background which greatly add to visibility of the data. Once I (conditionally) format data in one of the columns, the background "ladder" disappear in this column. I tried to restore the color manually by going to> format cell and putting the colors in the filling tab but there everything seems to e OK. But when I look at the table, the colors are not there.
Saying it in different words: I would like conditional formatting to change the color of the fonts but not the alternate rows' color of the background which orignally was in my table.
Is there a way to do it?
Any help will be greatly appreciated.
Is there a way to change color of letters (font) in a cell if it equals the value of another cell WITHOUT changing the background color?
My table has alternate rows of slightly different background which greatly add to visibility of the data. Once I (conditionally) format data in one of the columns, the background "ladder" disappear in this column. I tried to restore the color manually by going to> format cell and putting the colors in the filling tab but there everything seems to e OK. But when I look at the table, the colors are not there.
Saying it in different words: I would like conditional formatting to change the color of the fonts but not the alternate rows' color of the background which orignally was in my table.
Is there a way to do it?
Any help will be greatly appreciated.