Conditional formatting

  • Thread starter Thread starter ryan.fitzpatrick3
  • Start date Start date
R

ryan.fitzpatrick3

I think I have a bizarre question to ask. I have a row of numbers in
row 1, in row 2 I have inventory, is there a way to have a conditional
format in row 1 about row 2? for example I have 12 months, column A is
Jan, B is Feb, so on. The inventories in row 2 are depleting by month,
meaning the next month will have less than the previous since they are
being used up. in row 1 is the cost of the inventories in row 2. row 1
column A would be jan price for inventory in row 2 column A...make
sense so far? I would like to have a conditional format where when the
inventories in row 2, whereever in the year hit 0 or less than 0 row 1
(the price row) will be highlighted. As backwards as that sounds can
that be done?

Ryan
 
I think I have a bizarre question to ask. I have a row of numbers in
row 1, in row 2 I have inventory, is there a way to have a conditional
format in row 1 about row 2? for example I have 12 months, column A is
Jan, B is Feb, so on. The inventories in row 2 are depleting by month,
meaning the next month will have less than the previous since they are
being used up. in row 1 is the cost of the inventories in row 2. row 1
column A would be jan price for inventory in row 2 column A...make
sense so far? I would like to have a conditional format where when the
inventories in row 2, whereever in the year hit 0 or less than 0 row 1
(the price row) will be highlighted. As backwards as that sounds can
that be done?

Ryan
Click to expand...

Hi Ryan

Select cell A1 > Conditional format > Change "Cell value is" to
"Formula is" > Enter this formula =A2<1 > Change the format > Ok

Afterwards copy cell A1 and past to other columns. If you have values
or formulas in the other cells that you want to keep use "Past
special" and mark "Formats" > OK

Regards,

Per
 
Back
Top