{"id":12091,"date":"2011-11-20T07:05:54","date_gmt":"2011-11-20T07:05:54","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=717"},"modified":"2011-11-20T07:05:54","modified_gmt":"2011-11-20T07:05:54","slug":"conditional-formatting-based-on-condition-in-other-cell","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/11\/conditional-formatting-based-on-condition-in-other-cell\/","title":{"rendered":"Conditional Formatting based on Condition in other Cell"},"content":{"rendered":"

In previous post<\/a> we saw the normal conditional Formatting. It means based on the condition of a cell, changing the format of same cell is normal conditional formatting. But here we are going to see the conditional formatting of a cell based on some other cell condition. Suppose if you want to change the formatting of a cell based on condition on some other cell then follow the below steps:
\nExample: I want to change the Color of cell A1 if the Value of cell E1 is less than 5<\/strong>
\n
\nStep 1. Select the Cell A1
\nStep 2. Go to Home –> Conditional Formatting –>New Rule<\/strong>
\n

\"Conditional<\/a>

Conditional Formatting<\/p><\/div>
\n<\/p>\n

Step 3. Select “Use a formula to Determine which cell to Format”
\n\"Conditional-formatting\"
\nStep 4. Enter the Formula in the Formula Bar in the below Dialog
\nDO NOT put $ sign in the Cell Name for the Formula. If you are putting $ sign in the Cell Name like “$E$1” then this Conditional formatting will be applied only on this cell. If you want this formatting to apply on whole column then your formula should be like this “=E1<5\"<\/font><\/i><\/strong><\/p>\n

\"Conditional

Conditional formatting<\/p><\/div>\n

Step 5. Click ok
\nStep 6. Go to Home –> Conditional Formatting –>Manage Rules<\/strong>
\nStep 7. Now here you can change the Cell range in the “Apply To” field (as shown below) where you want to apply this conditional formatting.
\n\"Conditional-formatting\"
\nStep 8. After applying this Formatting on whole column, formatting of Column A will be done automatically as soon as we change the value in E column as shown below:
\n\"Conditional-formatting\"
\n Read this Also:<\/strong><\/p>\n