Conditional Formating


How i can format(conditional format) a cell in One excel Sheet, using the data of another excel sheet in same workbook.

i.e, i want if the 20 cell in a specific column is blank or its value is lower than a specific amount in Sheet 1, then in sheet 2 the color of the specified cell change to red or any other color.
Please help me in this Regard.

May 23rd, 2015 6:26am

Very Simple.. You need to create a name at workbook level.

Suppose you need to use A10 cell of Sheet1 as comparison and applying conditional formatting at C5 of Sheet3.

Then you need to create a name for it ( Formula Tab->Name Manager or Ctrl+F3 - > New -> New Name dialog boxappears-> Give a useful name to it in Name Text box ->Ok->Close)

and use in formula of Conditional Formatting.

Free Windows Admin Tool Kit Click here and download it now
May 23rd, 2015 2:39pm

Asslam o alaikum,
Asad ul Allah, I did this but not getting the result
Kindly Help.

What i want to do is this
if the Column H(Credit) is Blank or its value is lower than 4000 in this sheet

then in summary sheet the cell 'E7' Of ABC turned red

May 24th, 2015 1:35am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics