ExcelBanter - Formula for fill color?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formula for fill color? (https://www.excelbanter.com/excel-programming/385371-formula-fill-color.html)

[email protected]

Formula for fill color?

I'm trying to say "If D4<G2<D6, then make G2 a certain color". any
ideas? I keep getting errors. thanks!

Vergel Adriano

Formula for fill color?

Assume you're looking for the formula to put in the conditional format for
G2, try this:

=AND(G2D4, G2<D6)

" wrote:

I'm trying to say "If D4<G2<D6, then make G2 a certain color". any
ideas? I keep getting errors. thanks!

All times are GMT +1. The time now is 03:34 AM.