• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

REQUIRED CONDITIONAL FORMAT BY FORMULA

Hui

Excel Ninja
Staff member
Select Cells G10:G18
Select Conditional Formatting, New Rule, Use a Formula
use: =$H$7=1 and select White Font Color
The repeat the process
using =and($H$7=2,G10<0) as the formula
and apply the Red color

enjoy
 
Top