Hi there all,
Newbie here. I generally get by with Google searching but this one has me stumped. I've tried the conditional formatting/highlight cell rules/values greater for the problem below, without any luck.
I have a spreadsheet where every second column has the $rate for a specific item which is hidden by using the same font color as the cell fill color.
In the preceding column, when I input data (typically a number greater than zero and reflecting the quantities we require of that item), I want the hidden $rate font color to change to black. Therefore: preceding cell (A1) value of input data =>0, which then changes cell (B1) font color to black.
I just want to avoid a page full of figures for 100 items when we might only be ordering a few things.
Thanks in advance.
Bookmarks